﻿CREATE PROCEDURE [dbo].[sp_public_getRaceClasses]
	@Race_Id int
AS
SELECT Classes.Class_Id, Classes.Class_Name
FROM Races INNER JOIN
     Races_Classes_Relations ON Races.Race_Id = Races_Classes_Relations.Race2Class_Race INNER JOIN
     Classes ON Races_Classes_Relations.Race2Class_Class = Classes.Class_Id
	 WHERE Race_Id = @Race_Id
RETURN 0